# coding: utf-8

from application import db


class User(db.Model):
    __tablename__ = 'user'

    user_Id = db.Column(db.String(50), primary_key=True)
    user_code = db.Column(db.String(100))
    user_name = db.Column(db.String(200))
    password = db.Column(db.String(200))
    email = db.Column(db.String(200))
    mobile = db.Column(db.String(100))
    address = db.Column(db.String(100))
    status = db.Column(db.String(1))
    organize_id = db.Column(db.String(50))
    role_Id = db.Column(db.String(50))
    company_id = db.Column(db.String(64))
    user_type = db.Column(db.String(64))
    photo = db.Column(db.String(1000))
    integral = db.Column(db.Integer)
    login_ip = db.Column(db.String(1000))
    login_date = db.Column(db.DateTime)
    login_flag = db.Column(db.String(64))
    qrcode = db.Column(db.String(64))
    delflage = db.Column(db.Integer)
    create_time = db.Column(db.DateTime)
    create_user = db.Column(db.String(200))
    update_time = db.Column(db.DateTime)
    update_user = db.Column(db.String(200))
